<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_attribute`;");
E_C("CREATE TABLE `ecs_attribute` (
  `attr_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `cat_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `attr_name` varchar(60) NOT NULL DEFAULT '',
  `attr_input_type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `attr_type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `attr_values` text NOT NULL,
  `attr_index` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `sort_order` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `is_linked` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `attr_group` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`attr_id`),
  KEY `cat_id` (`cat_id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_attribute` values('1','1','品牌','1','0','Chanel/香奈儿\r\nDior/迪奥\r\nGucci/古奇','0','1','0','0');");
E_D("replace into `ecs_attribute` values('2','1','适用人群','1','0','女士\r\n男士\r\n中性','0','3','0','0');");
E_D("replace into `ecs_attribute` values('3','1','香味','1','0','香草\r\n苹果\r\n玫瑰','0','4','0','0');");
E_D("replace into `ecs_attribute` values('4','1','香水容量','1','0','30ML\r\n50ML\r\n100ML','0','5','0','0');");
E_D("replace into `ecs_attribute` values('5','1','彩妆规格','1','0','正常规格\r\n小样/中样\r\n套装/礼盒\r\n简装/试用装','0','6','0','0');");
E_D("replace into `ecs_attribute` values('6','1','香调','1','0','树木香调\r\n花果香调\r\n花香调\r\n东方香调\r\n海洋香调\r\n森林香调\r\n混合香调\r\n琥珀香调','0','7','0','0');");
E_D("replace into `ecs_attribute` values('7','1','香水分类','1','0','淡香水EDT\r\n香水EDP\r\n固体香水/香膏\r\n古龙水EDC\r\n淡香氛\r\n香体乳\r\n香精parfum','0','2','0','0');");
E_D("replace into `ecs_attribute` values('8','1','适合肤质','1','0','所有肤质','0','8','0','0');");
E_D("replace into `ecs_attribute` values('9','2','分类','1','0','面部护理套装 \r\n乳液/面霜 \r\n面膜 \r\n洁面 \r\n化妆水/爽肤水 \r\n眼部护理 \r\n面部精华 \r\n身体护理 \r\n男士护理 \r\n防晒 \r\n卸妆 \r\n精油芳疗 \r\n手部保养 \r\n唇部护理 \r\n面部磨砂/去角质 \r\n胸部护理 \r\nT区护理 \r\n瘦身纤体 \r\n面部按摩霜 \r\n其他保养','0','1','0','0');");
E_D("replace into `ecs_attribute` values('10','2','品牌','1','0','Lancome/兰蔻\r\nPROYA/珀莱雅\r\nL＇oreal/欧莱雅\r\nLaneige/兰芝\r\nOlay/玉兰油\r\nEsteeLauder/雅诗兰黛\r\n相宜本草\r\nCHANDO/自然堂\r\n雪花秀\r\nMarykay/玫琳凯\r\nPECHOIN/百雀羚\r\nMentholatum/曼秀雷敦\r\n美肤宝\r\nAvon/雅芳\r\nKans/韩束\r\nClinique/倩碧\r\nShiseido/资生堂\r\nNivea/妮维雅','0','2','0','0');");
E_D("replace into `ecs_attribute` values('11','2','规格','1','0','正常规格\r\n小样/中样','0','3','0','0');");
E_D("replace into `ecs_attribute` values('12','3','熏香原料','1','0','塔香\r\n线香\r\n盘香\r\n香粉\r\n口袋香','0','2','0','0');");
E_D("replace into `ecs_attribute` values('13','3','香料功能','1','0','舒缓精神\r\n净化空气\r\n振奋精神','0','3','0','0');");
E_D("replace into `ecs_attribute` values('14','3','香薰产地','1','0','中国\r\n印度\r\n泰国\r\n法国\r\n日本','0','4','0','0');");
E_D("replace into `ecs_attribute` values('15','3','香味','1','0','柠檬\r\n柑橘\r\n玫瑰\r\n苹果\r\n茉莉\r\n佛手柑\r\n水蜜桃\r\n睡莲 ','0','5','0','0');");
E_D("replace into `ecs_attribute` values('16','3','品牌','1','0','弗罗曼莎\r\n金王\r\n哈乐猫\r\n木之森','0','1','0','0');");

require("../../inc/footer.php");
?>